package com.pengtu.gsj.dao.check.gcjs;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.pengtu.gsj.dao.hibernate.HibernateDao;
import com.pengtu.gsj.entity.gcjs.YHRoadConstructionB;

/**
 * 
 * 
 * YHRoadConstructionBDao
 * 
 * 2017年5月26日 下午3:57:00
 * 
 * @version 1.0.0
 *
 */
@Repository
public class YHRoadConstructionBDao extends HibernateDao<YHRoadConstructionB, String> {

	public List<YHRoadConstructionB> getRoadHardenConBpros(String startTime, String endTime) {
		String hql = "select new com.pengtu.gsj.entity.gcjs.YHRoadConstructionB(t.projectName) from YHRoadConstructionB t where t.delFlag='0'and t.testYear <="+endTime+"and t.testYear >="+startTime+" group by t.testYear order by t.testYear asc";
		return find(hql);
	}

	public YHRoadConstructionB getCheckDataById(String projectNameId) {
		return get(projectNameId);
	}
}
